{{ statistics.total_tables }} tables Β· {{ statistics.total_measures }} measures Β· {{ statistics.total_relationships }} relationships Β· {{ statistics.total_pages }} pages Β· {{ statistics.total_visuals }} visuals
{{ tableDistribution.fact }}% fact Β· {{ tableDistribution.dimension }}% dimension
Avg {{ avgColumnsPerTable }} columns/table
Avg {{ avgMeasuresPerTable }} measures/table
{{ measureToColumnRatio }}:1 measure/column ratio
{{ measuresUsedPct }}% measures in use
{{ columnsUsedPct }}% columns referenced
{{ statistics.total_relationships }} active relationships
{{ healthSummary }}
Select a table from the left to view details
Select a measure from the left to view its DAX code
Select a page from the left to view visuals
Select a measure from the left to view dependencies
Select a column from the left to view usage
Select a measure from the left to view its complete dependency chain
Select a page and visual from the left to trace measure dependencies
Analysis based on Microsoft Power BI Best Practices
{{ bpaTotalViolations }}
{{ bpaErrorCount }}
{{ bpaWarningCount }}
{{ bpaInfoCount }}
| Severity | Rule | Object | Description |
|---|---|---|---|
| {{ violation.severity }} | {{ violation.rule_name }} |
{{ violation.object_name }}
Table: {{ violation.table_name }}
|
{{ violation.description }}
{{ violation.details }}
|
No violations found
Total Violations
{{ namingViolationsCount }}
Warnings
{{ namingSummary.by_severity?.WARNING || 0 }}
Info
{{ namingSummary.by_severity?.INFO || 0 }}
| Severity | Type | Object Type | Table | Object | Issue | Current Name |
|---|---|---|---|---|---|---|
| {{ violation.severity }} | {{ violation.type }} | {{ violation.object_type }} | {{ violation.table }} | {{ violation.object }} | {{ violation.issue }} | {{ violation.current_name }} |
Data type optimization and cardinality warnings
{{ dataTypeIssues.length }}
{{ dataTypeHighImpactCount }}
| Table | Column | Current Type | Issue | Recommendation | Impact |
|---|---|---|---|---|---|
| {{ issue.table }} | {{ issue.column }} |
{{ issue.current_type }}
|
{{ issue.issue }} | {{ issue.recommendation }} | {{ issue.impact }} |
| Table | Column | Reason | Is Hidden | Recommendation |
|---|---|---|---|---|
| {{ warning.table }} | {{ warning.column }} | {{ warning.reason }} | {{ warning.is_hidden ? 'β Yes' : 'β No' }} | {{ warning.recommendation }} |
Complexity metrics and anti-pattern detection
{{ daxSummary.total_measures || 0 }}
{{ daxSummary.avg_complexity || 0 }}
{{ daxSummary.high_complexity_measures || 0 }}
{{ daxQualityIssues.length }}
| Severity | Type {{ daxQualitySortDesc ? 'βΌ' : 'β²' }} | Table {{ daxQualitySortDesc ? 'βΌ' : 'β²' }} | Measure {{ daxQualitySortDesc ? 'βΌ' : 'β²' }} | Issue | Recommendation | Complexity {{ daxQualitySortDesc ? 'βΌ' : 'β²' }} |
|---|---|---|---|---|---|---|
|
{{ collapsedDaxTypeGroups[type] ? 'βΆ' : 'βΌ' }}
{{ type }}
({{ issues.length }} issue{{ issues.length !== 1 ? 's' : '' }})
|
||||||
| {{ issue.severity }} | {{ issue.type }} | {{ issue.table }} | {{ issue.issue }} | {{ issue.recommendation }} | {{ issue.complexity_score }} | |
Track column usage and impact across the model
{{ Object.keys(columnLineage).length }}
{{ orphanColumnsCount }}
{{ calculatedColumnsCount }}
{{ highUsageColumnsCount }}
| Table {{ lineageSortDesc ? 'βΌ' : 'β²' }} | Column {{ lineageSortDesc ? 'βΌ' : 'β²' }} | Type {{ lineageSortDesc ? 'βΌ' : 'β²' }} | Data Type {{ lineageSortDesc ? 'βΌ' : 'β²' }} | In Measures {{ lineageSortDesc ? 'βΌ' : 'β²' }} | In Relationships {{ lineageSortDesc ? 'βΌ' : 'β²' }} | In Visuals {{ lineageSortDesc ? 'βΌ' : 'β²' }} | Usage Score {{ lineageSortDesc ? 'βΌ' : 'β²' }} | Status {{ lineageSortDesc ? 'βΌ' : 'β²' }} |
|---|---|---|---|---|---|---|---|---|
| {{ lineage.table }} | {{ lineage.column }} | Calculated Physical | {{ lineage.data_type }} | {{ lineage.used_in_measures?.length || 0 }} | {{ lineage.used_in_relationships?.length || 0 }} | {{ lineage.used_in_visuals?.length || 0 }} | {{ lineage.usage_score }} | Orphan In Use |
Object visibility and perspective usage
{{ perspectivesData.message }}
{{ perspectivesCount }}
{{ perspectivesData.unused_perspectives?.length || 0 }}
{{ perspectivesCount - (perspectivesData.unused_perspectives?.length || 0) }}
Tables
{{ perspective.table_count }}
Columns
{{ perspective.column_count }}
Measures
{{ perspective.measure_count }}
Total Objects
{{ perspective.total_objects }}